package com.hjf.dao.impl;

import java.util.List;

import com.commons.po.CustomerRole;
import com.commons.po.DeptPo;
import com.dao.BaseDao;
import com.hjf.dao.CustomerRoleDao;

public class CustomerRoleDaoImpl extends BaseDao<CustomerRole> implements CustomerRoleDao {

	@Override
	public List<CustomerRole> findAllCustomerRole() {
		String sql="select * from user_role";
		return this.executeQuery(sql, null, CustomerRole.class, null);
	}

	@Override
	public List<CustomerRole> findByCustomerId(Integer customerId) {
		String sql="select * from user_role where user_id=?";
		Object[] paramsObjs={customerId};
		return this.executeQuery(sql, null, CustomerRole.class, paramsObjs);
	}

}
